How to: Use the COUNT() function to count objects.
Solution:
Select the cell where the count result should appear. Enter = COUNT(<cell range>), where <cell range> is a range of cells.
1) Select the cell where the count result should appear. (The cell is highlighted.)
2) Type an equal sign and the COUNT command in the cell:
=COUNT()
3) Do one of the following to specify the cell range to be counted:
a) Type the range reference within the parentheses of the COUNT command.
EXAMPLE: =COUNT(D5:D10)
NOTE: No spaces should exist in the formula. For multiple ranges, separate each range with a comma.
b) Select the desired range with the mouse.
NOTE: Be sure that the range is included in the parentheses. For multiple ranges, separate each range with a comma.
4) Press ENTER. (Excel displays the result in the selected cell.)
NOTE: The COUNT command can be used to work with large cell ranges. For example, it can be used to count the number of records in a database. The command includes cells that have the value '0' but excludes cells that are blank.
